Run Migrations in BigDb

Run database setup, upgrades, & downgrade.

Create Migrations, Stored SQL, CRUD

Docs

• Migrate Via CLI
• Migrate in PHP

Migrate via CLI

You must first create a bin script for your BigDb setup. See CLI

// list available migrations  
bin/yourdb list-migrations  
  
// syntax  
bin/yourdb migrate [current_version] [target_version]  
  
// initialize database, from version zero to version one.  
bin/yourdb migrate 0 1  
  
// upgrade from version 1 to version 3  
bin/yourdb migrate1 3  

Migrate in PHP

Initialize the library's databse & call $db->migrate(old_version, new_version)

<?php  
$pdo = new \PDO('mysql:dbname='.$db_name.';host='.$db_host, $user_name, $password);  
  
$db = new \Tlf\BigDb\Test\ArticleDb($pdo);   
  
// initialize database  
$db->migrate(0,1);   
  
// upgrade from version 1 to version 3  
$db->migrate(1,3);